USE clothing

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'proc_select_postionInfo') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP PROC proc_select_postioninfo 
  END 

go 

CREATE PROC Proc_select_postioninfo 
AS 
  BEGIN 
      SET NOCOUNT ON 

      SELECT * 
      FROM   dbo.postioninfo 
  END 

go   